<cfparam default="none" name="url.type" />
<cfparam default="none" name="url.api" />

<cfset BASE = CreateObject("component", "cfc.base") />

<!---             REPORTS                                                        --->
<cfoutput>


    <!--- API that shows Master Activiy  Function:  --->
	<cfif url.api eq "master_activity" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset QUERIES.masterActivity = CreateObject("component", "cfc.reports").funcQryMaterActiviyReportAll(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/masteractivity.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Master Activiy  Function:  --->



    <!--- API that shows Master Activiy PDF  Function:  --->
	<cfif url.api eq "master_activity_pdf" >
     <cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset PageType = "PDF" />
                <cfset QUERIES.masterActivity = CreateObject("component", "cfc.reports").funcQryMaterActiviyReportAll(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/masteractivity.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Master Activiy PDF  Function:  --->




    <!--- API that shows Undup Services  Function:  --->
	<cfif url.api eq "undup_services" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.BillingType" />
				<cfset UnDupServices = CreateObject("component", "cfc.reports").funcQryUnDupServices(url.DateFrom, url.DateTo) />
                <cfset UnDupMeals = CreateObject("component", "cfc.reports").funcQryUnDupMeals(url.DateFrom, url.DateTo) />
                <cfset UnDupServiceOrMeals = CreateObject("component", "cfc.reports").funcQryUnDupServiceOrMeals(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/undupservices.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Undup Services  Function:  --->




    <!--- API that shows Undup Services PDF Function:  --->
	<cfif url.api eq "undup_services_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset PageType = "PDF" />
                <cfset UnDupServices = CreateObject("component", "cfc.reports").funcQryUnDupServices(url.DateFrom, url.DateTo) />
                <cfset UnDupMeals = CreateObject("component", "cfc.reports").funcQryUnDupMeals(url.DateFrom, url.DateTo) />
                <cfset UnDupServiceOrMeals = CreateObject("component", "cfc.reports").funcQryUnDupServiceOrMeals(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/undupservices.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Undup Services PDF Function:  --->



    <!--- API that shows Billable Services Function:  --->
	<cfif url.api eq "billable_services" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.BillingType" />
                <cfset BillableServices = CreateObject("component", "cfc.reports").funcQryBillableServices(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billableservices.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Billable Services Function:  --->


    <!--- API that shows Billable Services PDF Function:  --->
	<cfif url.api eq "billable_services_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.BillingType" />
                <cfset PageType = "PDF" />
                <cfset BillableServices = CreateObject("component", "cfc.reports").funcQryBillableServices(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billableservices.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Billable Services PDF Function:  --->


    <!--- API that shows Billable Services XLS Function:  --->
	<cfif url.api eq "billable_services_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.BillingType" />
                <cfset PageType = "XLS" />
                <cfset BillableServices = CreateObject("component", "cfc.reports").funcQryBillableServices(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billableservices.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Billable Services XLS Function:  --->


    <!--- API that shows Service Plan Targets:  --->
	<cfif url.api eq "service_plan_target" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.ProviderID" />
				<cfset ServicePlanTargets = CreateObject("component", "cfc.reports").funcQryServicePlansTargets(url.DateFrom, url.DateTo, url.ProviderID) />
                <cfset ElderDPNs = CreateObject("component", "cfc.reports").funcQryDPNTargets(url.DateFrom, url.DateTo, url.ProviderID) />
                <cfset Provider = CreateObject("component", "cfc.reports").funcQryProvidersByID(url.ProviderID) />
				<cfinclude template="reports/serviceplantargets.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Service Plan Targets:  --->



    <!--- API that shows Service Plan XLS Targets:  --->
	<cfif url.api eq "service_plan_target_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.ProviderID" />
                <Cfset PageType = "XLS" />
                <cfset ServicePlanTargets = CreateObject("component", "cfc.reports").funcQryServicePlansTargets(url.DateFrom, url.DateTo, url.ProviderID) />
                <cfset ElderDPNs = CreateObject("component", "cfc.reports").funcQryDPNTargets(url.DateFrom, url.DateTo, url.ProviderID) />
                <cfset Provider = CreateObject("component", "cfc.reports").funcQryProvidersByID(url.ProviderID) />
				<cfinclude template="reports/serviceplantargets.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Service Plan XLS Targets:  --->


    <!--- API that shows medicaid billing:  --->
	<cfif url.api eq "medicaid_billing" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfparam default="-1" name="url.BillingType" />
                <cfif url.BillingType EQ "Transportation">
					<cfset MedicaidBilling = CreateObject("component", "cfc.reports").funcQryMedicaidBillingTransportation(url.DateFrom, url.DateTo) />
                <cfelseif url.BillingType EQ "Chore">
                    <cfset MedicaidBilling = CreateObject("component", "cfc.reports").funcQryMedicaidBillingChore(url.DateFrom, url.DateTo) />
                <cfelseif url.BillingType EQ "Meal">
                    <cfset MedicaidBilling = CreateObject("component", "cfc.reports").funcQryMedicaidBillingMeal(url.DateFrom, url.DateTo) />
                <cfelseif url.BillingType EQ "TTCM">
                    <cfset MedicaidBilling = CreateObject("component", "cfc.reports").funcQryMedicaidBillingTTCM(url.DateFrom, url.DateTo) />
                <cfelse>

                </cfif>
				<cfinclude template="reports/medicaidbilling.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows medicaid billing:  --->


    <!--- API that shows billing report:  --->
	<cfif url.api eq "billing_report" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryBillingReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billingreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows billing report:  --->


    <!--- API that shows billing report xls:  --->
	<cfif url.api eq "billing_report_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset PageType = "XLS" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryBillingReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billingreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows billing report xls:  --->


    <!--- API that shows billing report pdf:  --->
	<cfif url.api eq "billing_report_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset PageType = "PDF" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryBillingReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/billingreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows billing report pdf:  --->




    <!--- API that shows services report:  --->
	<cfif url.api eq "services_report" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryServicesReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/servicesreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows services report:  --->



    <!--- API that shows services report:  --->
	<cfif url.api eq "services_report_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
            	<cfset PageType = "XLS" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryServicesReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/servicesreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows services report:  --->




    <!--- API that shows services report:  --->
	<cfif url.api eq "services_report_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateFrom" />
            	<cfparam default="#dateFormat(now(), 'mm/dd/yyyy')#" name="url.DateTo" />
            	<cfset PageType = "PDF" />
                <cfset BillingReport = CreateObject("component", "cfc.reports").funcQryServicesReport(url.DateFrom, url.DateTo) />
				<cfinclude template="reports/servicesreport.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows services report:  --->



    <!--- API that shows ProviderDistribution Function:  --->
	<cfif url.api eq "provider_distribution" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset QUERIES.providerDistribution = CreateObject("component", "cfc.reports").funcQryProviderDistribution() />
            	<cfset util = CreateObject("component", "cfc.utilities") />
				<cfinclude template="reports/providerdistribution.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows ProviderDistribution Function:  --->



    <!--- API that shows ProviderDistribution PDF Function:  --->
	<cfif url.api eq "provider_distribution_pdf" >
    	<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "PDF" />
                <cfset QUERIES.providerDistribution = CreateObject("component", "cfc.reports").funcQryProviderDistribution() />
                <cfset util = CreateObject("component", "cfc.utilities") />
				<cfinclude template="reports/providerdistribution.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows ProviderDistribution PDF Function:  --->



    <!--- API that shows Ethnicity report:  --->
	<cfif url.api eq "ethnicity_report" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset QUERIES.ethnicityDistribution = CreateObject("component", "cfc.reports").funcQryEthnicityDistribution() />
				<cfinclude template="reports/ethnicity.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Ethnicity report:  --->



    <!--- API that shows Ethnicity report PDF:  --->
	<cfif url.api eq "ethnicity_report_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "PDF" />
                <cfset QUERIES.ethnicityDistribution = CreateObject("component", "cfc.reports").funcQryEthnicityDistribution() />
				<cfinclude template="reports/ethnicity.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Ethnicity report PDF:  --->



    <!--- API that shows RegionalCorp report:  --->
	<cfif url.api eq "regionalcorp_report" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset QUERIES.regionalcorpDistribution = CreateObject("component", "cfc.reports").funcQryRegionalCorpDistribution() />
				<cfinclude template="reports/regionalcorp.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows RegionalCorp report:  --->
    

    <!--- API that shows RegionalCorp report PDF:  --->
	<cfif url.api eq "regionalcorp_report_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "PDF" />
                <cfset QUERIES.regionalcorpDistribution = CreateObject("component", "cfc.reports").funcQryRegionalCorpDistribution() />
				<cfinclude template="reports/regionalcorp.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows RegionalCorp report PDF:  --->
    
    
    
    <!--- API that shows Mailing List of elders report:  --->
    <cfif url.api eq "no_priority_list" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoPriorityList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noprioritylist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders report:  --->
    
    
    
    <!--- API that shows Mailing List of elders PDF report:  --->
    <cfif url.api eq "no_priority_list_pdf" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset PageType = "PDF" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoPriorityList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noprioritylist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders PDF report:  --->
    
    
    
    
    
    <!--- API that shows Mailing List of elders XLS report:  --->
    <cfif url.api eq "no_priority_list_xls" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset PageType = "XlS" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoPriorityList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noprioritylist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders XLS report:  --->
    
    
    
    <!--- API that shows Mailing List of elders report:  --->
    <cfif url.api eq "no_provider_list" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoProviderList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noproviderlist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders report:  --->
    
    
    
    <!--- API that shows Mailing List of elders PDF report:  --->
    <cfif url.api eq "no_provider_list_pdf" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset PageType = "PDF" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoProviderList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noproviderlist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders PDF report:  --->
    
    
    
    
    
    <!--- API that shows Mailing List of elders XLS report:  --->
    <cfif url.api eq "no_provider_list_xls" >
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
                <cfset PageType = "XlS" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryNoProviderList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
                <cfinclude template="reports/noproviderlist.cfm" />
            </cfcase>
        </cfswitch>
    </cfif>
    <!--- API that shows Mailing List of elders XLS report:  --->
    
    
    
    <!--- API that shows Mailing List of elders report:  --->
	<cfif url.api eq "mailing_list" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryMailingList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/mailinglist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Mailing List of elders report:  --->
    
    
    
    <!--- API that shows Mailing List of elders PDF report:  --->
	<cfif url.api eq "mailing_list_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "PDF" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryMailingList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/mailinglist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Mailing List of elders PDF report:  --->
    
    
    
    
    
    <!--- API that shows Mailing List of elders XLS report:  --->
	<cfif url.api eq "mailing_list_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "XlS" />
                <cfset QUERIES.MailingList = CreateObject("component", "cfc.reports").funcQryMailingList(9) />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/mailinglist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Mailing List of elders XLS report:  --->
    
    
    
    
    
    <!--- API that shows Active Client List of elders report:  --->
	<cfif url.api eq "active_client_list" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
                <cfset QUERIES.ActivceClientList = CreateObject("component", "cfc.reports").funcQryActivceClientList() />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/activeclientlist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Active Client List of elders report:  --->
    
    
    
    <!--- API that shows Active Client List of elders PDF report:  --->
	<cfif url.api eq "active_client_list_pdf" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "PDF" />
                <cfset QUERIES.ActivceClientList = CreateObject("component", "cfc.reports").funcQryActivceClientList() />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/activeclientlist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Active Client List of elders PDF report:  --->
    
    
    
    
    
    <!--- API that shows Active Client List of elders XLS report:  --->
	<cfif url.api eq "active_client_list_xls" >
		<cfswitch expression="#CGI.REQUEST_METHOD#">
    		<cfcase value="POST" >
            	<cfset PageType = "XlS" />
                <cfset QUERIES.ActivceClientList = CreateObject("component", "cfc.reports").funcQryActivceClientList() />
                <cfset util = CreateObject("component", "cfc.utilities") />
                <cfset qry = CreateObject("component", "cfc.reports") />
                <cfset BASE = CreateObject("component", "cfc.base") />
				<cfinclude template="reports/activeclientlist.cfm" />
            </cfcase>
   	 	</cfswitch>
    </cfif>
	<!--- API that shows Active Client List of elders XLS report:  --->
    
    
    
    

</cfoutput>
<!---             REPORTS                                                        --->